
-- Project: Lazarus
-- Script to drop all data from the tables.

SET NOCOUNT ON;
      
SET ANSI_NULLS ON 
GO

-- Delete Data from all Tables.
TRUNCATE TABLE [tblExpertiseLevel];
TRUNCATE TABLE [tblTechnology];
TRUNCATE TABLE [tblGoalStatus];
TRUNCATE TABLE [tblGoal];
TRUNCATE TABLE [tblGoalRequiredExpertise];
GO
	
	

-- Reseed IDENTITY columns.
DBCC CHECKIDENT( 'tblExpertiseLevel', RESEED, 1 );
DBCC CHECKIDENT( 'tblTechnology', RESEED, 1 );
DBCC CHECKIDENT( 'tblGoalStatus', RESEED, 1 );
DBCC CHECKIDENT( 'tblGoal', RESEED, 1 );
DBCC CHECKIDENT( 'tblGoalRequiredExpertise', RESEED, 1 );


SET ANSI_NULLS OFF
GO   
		
	